create external table jms_ods.yl_elec_recycle
(
    ID                  bigint comment'唯一主键',
    BILL_CODE           string comment'运单号',
    TRACE_ID            string comment'回收流水号',
    RECYCLE_OBJECT      bigint comment'回收对象类型1-业务员 2-网点 3-客户',
    RECYCLE_STATUS      bigint comment'回收状态 0-不回收 1-已回收 2-回收失败 3-已管控',
    RECYCLE_TIME        timestamp comment'回收时间',
    RECYCLE_FAIL_REASON string comment'回收失败原因',
    GET_TIME            timestamp comment'单号获取时间',
    SITE_CODE           string comment'网点编号',
    SITE_NAME           string comment'网点名称',
    MALL_ID             string comment'商户id',
    MALL_NAME           string comment'商户名称',
    CUSTOMER_CODE       string comment'客户编码',
    SOURCE_CODE         string comment'来源 0 通用 1 pdd 2 云集  3 抖音  4 京东 5 快手 6菜鸟 7纸质二维码',
    SCAN_STATUS         string comment'运单扫描状态',
    REMARKS             string comment'备注',
    CREATE_TIME         timestamp comment'创建时间',
    UPDATE_TIME         timestamp comment'修改时间',
    CUSTOMER_NAME       string comment'客户名称',
    SALE_CODE           string comment'业务员编号',
    SALE_NAME           string comment'业务员名称'
)
 COMMENT '电子面单回收明细'
 PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
 STORED AS PARQUET
 LOCATION '/dw/hive/jms_ods.db/external/yl_elec_recycle'
 TBLPROPERTIES (
 'discover.partitions'='false',
 'parquet.column.index.access'='true'
 );
